package br.gov.ce.fortaleza.cti.util;

public class Util {

	public static final String INSERT_TRANSMISSAO = "INSERT INTO TB_TRANSMISSAO(codveiculo, x, y,velocidade, data_transmissao) VALUES (?, ?, ?, ?, ?)";



	public static final String FIND_VEICULOS = "SELECT V.CODVEICULO FROM VEICULO V";

	public static final String FIND_VEICULOS_SEM_TRANSMISSAO =
			" SELECT V.CODVEICULO, V.DSC_VEICULO, P.DESC_PONTO, U.DIST_PONTO, U.DATA_TRANSMISSAO " +
					" FROM ULTIMA_TRANSMISSAO U " +
					" INNER JOIN VEICULO V ON U.SEQ_VEICULO = V.SEQ_VEICULO " +
					" INNER JOIN PONTO P ON U.SEQ_PONTO = P.SEQ_PONTO " +
					" WHERE TIMESTAMPDIFF(HOUR, DATA_TRANSMISSAO, now()) > 24";


	public static final String INSERT_TRANSMISSAO_ALLFIELDS = "INSERT INTO TB_TRANSMISSAO VALUES (0, ?, 0, GeomFromText(?), 0, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0, ?)";
	

}
